Overview

Dataset statistics

Number of variables13
Number of observations2969
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory301.7 KiB
Average record size in memory104.0 B

Variable types

Numeric11
Categorical2

Alerts

qtde_products has a high cardinality: 2967 distinct values High cardinality
avg_recency_days has a high cardinality: 290 distinct values High cardinality
gross_revenue is highly correlated with qtde_invoices and 2 other fieldsHigh correlation
recency_days is highly correlated with qtde_invoicesHigh correlation
qtde_invoices is highly correlated with gross_revenue and 2 other fieldsHigh correlation
qtde_items is highly correlated with gross_revenue and 2 other fieldsHigh correlation
avg_ticket is highly correlated with avg_unique_basket_sizeHigh correlation
avg_basket_size is highly correlated with gross_revenue and 1 other fieldsHigh correlation
avg_unique_basket_size is highly correlated with avg_ticketHigh correlation
gross_revenue is highly correlated with qtde_invoices and 1 other fieldsHigh correlation
qtde_invoices is highly correlated with gross_revenue and 1 other fieldsHigh correlation
qtde_items is highly correlated with gross_revenue and 1 other fieldsHigh correlation
avg_ticket is highly correlated with qtde_returns and 1 other fieldsHigh correlation
qtde_returns is highly correlated with avg_ticket and 1 other fieldsHigh correlation
avg_basket_size is highly correlated with avg_ticket and 1 other fieldsHigh correlation
gross_revenue is highly correlated with qtde_invoices and 1 other fieldsHigh correlation
qtde_invoices is highly correlated with gross_revenue and 1 other fieldsHigh correlation
qtde_items is highly correlated with gross_revenue and 2 other fieldsHigh correlation
avg_basket_size is highly correlated with qtde_itemsHigh correlation
gross_revenue is highly correlated with qtde_invoices and 4 other fieldsHigh correlation
qtde_invoices is highly correlated with gross_revenue and 1 other fieldsHigh correlation
qtde_items is highly correlated with gross_revenue and 4 other fieldsHigh correlation
avg_ticket is highly correlated with gross_revenue and 3 other fieldsHigh correlation
qtde_returns is highly correlated with gross_revenue and 3 other fieldsHigh correlation
avg_basket_size is highly correlated with gross_revenue and 3 other fieldsHigh correlation
avg_ticket is highly skewed (γ1 = 53.4442279) Skewed
qtde_returns is highly skewed (γ1 = 51.79774426) Skewed
avg_basket_size is highly skewed (γ1 = 44.68328098) Skewed
qtde_products is uniformly distributed Uniform
df_index has unique values Unique
customer_id has unique values Unique
recency_days has 34 (1.1%) zeros Zeros
qtde_returns has 1481 (49.9%) zeros Zeros

Reproduction

Analysis started2022-07-29 13:42:28.506436
Analysis finished2022-07-29 13:42:46.895998
Duration18.39 seconds
Software versionpandas-profiling v3.2.0
Download configurationconfig.json

Variables

df_index
Real number (ℝ≥0)

UNIQUE

Distinct2969
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2317.292354
Minimum0
Maximum5715
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-07-29T10:42:46.961318image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile185.4
Q1929
median2120
Q33537
95-th percentile5035.2
Maximum5715
Range5715
Interquartile range (IQR)2608

Descriptive statistics

Standard deviation1554.944589
Coefficient of variation (CV)0.6710178739
Kurtosis-1.010787014
Mean2317.292354
Median Absolute Deviation (MAD)1271
Skewness0.342284058
Sum6880041
Variance2417852.674
MonotonicityStrictly increasing
2022-07-29T10:42:47.069730image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
01
 
< 0.1%
30111
 
< 0.1%
29961
 
< 0.1%
29991
 
< 0.1%
30001
 
< 0.1%
30011
 
< 0.1%
30021
 
< 0.1%
30051
 
< 0.1%
30071
 
< 0.1%
30081
 
< 0.1%
Other values (2959)2959
99.7%
ValueCountFrequency (%)
01
< 0.1%
11
< 0.1%
21
< 0.1%
31
< 0.1%
41
< 0.1%
51
< 0.1%
61
< 0.1%
71
< 0.1%
81
< 0.1%
91
< 0.1%
ValueCountFrequency (%)
57151
< 0.1%
56961
< 0.1%
56861
< 0.1%
56801
< 0.1%
56591
< 0.1%
56551
< 0.1%
56491
< 0.1%
56381
< 0.1%
56371
< 0.1%
56271
< 0.1%

customer_id
Real number (ℝ≥0)

UNIQUE

Distinct2969
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15270.77299
Minimum12347
Maximum18287
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-07-29T10:42:47.183764image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Quantile statistics

Minimum12347
5-th percentile12619.4
Q113799
median15221
Q316768
95-th percentile17964.6
Maximum18287
Range5940
Interquartile range (IQR)2969

Descriptive statistics

Standard deviation1718.990292
Coefficient of variation (CV)0.1125673398
Kurtosis-1.206094692
Mean15270.77299
Median Absolute Deviation (MAD)1488
Skewness0.03160785866
Sum45338925
Variance2954927.624
MonotonicityNot monotonic
2022-07-29T10:42:47.290441image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
178501
 
< 0.1%
175881
 
< 0.1%
149051
 
< 0.1%
161031
 
< 0.1%
146261
 
< 0.1%
148681
 
< 0.1%
182461
 
< 0.1%
171151
 
< 0.1%
166111
 
< 0.1%
159121
 
< 0.1%
Other values (2959)2959
99.7%
ValueCountFrequency (%)
123471
< 0.1%
123481
< 0.1%
123521
< 0.1%
123561
< 0.1%
123581
< 0.1%
123591
< 0.1%
123601
< 0.1%
123621
< 0.1%
123641
< 0.1%
123701
< 0.1%
ValueCountFrequency (%)
182871
< 0.1%
182831
< 0.1%
182821
< 0.1%
182771
< 0.1%
182761
< 0.1%
182741
< 0.1%
182731
< 0.1%
182721
< 0.1%
182701
< 0.1%
182691
< 0.1%

gross_revenue
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct2954
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2749.226056
Minimum6.2
Maximum279138.02
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-07-29T10:42:47.405453image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Quantile statistics

Minimum6.2
5-th percentile229.77
Q1570.96
median1086.92
Q32308.06
95-th percentile7219.68
Maximum279138.02
Range279131.82
Interquartile range (IQR)1737.1

Descriptive statistics

Standard deviation10580.4905
Coefficient of variation (CV)3.848534202
Kurtosis353.9585684
Mean2749.226056
Median Absolute Deviation (MAD)672.72
Skewness16.77787915
Sum8162452.16
Variance111946779.3
MonotonicityNot monotonic
2022-07-29T10:42:47.514085image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
178.962
 
0.1%
533.332
 
0.1%
889.932
 
0.1%
2053.022
 
0.1%
745.062
 
0.1%
379.652
 
0.1%
2092.322
 
0.1%
731.92
 
0.1%
1353.742
 
0.1%
3312
 
0.1%
Other values (2944)2949
99.3%
ValueCountFrequency (%)
6.21
< 0.1%
13.31
< 0.1%
151
< 0.1%
36.561
< 0.1%
451
< 0.1%
521
< 0.1%
52.21
< 0.1%
52.21
< 0.1%
62.431
< 0.1%
68.841
< 0.1%
ValueCountFrequency (%)
279138.021
< 0.1%
259657.31
< 0.1%
194550.791
< 0.1%
168472.51
< 0.1%
140438.721
< 0.1%
124564.531
< 0.1%
117375.631
< 0.1%
91062.381
< 0.1%
72882.091
< 0.1%
66653.561
< 0.1%

recency_days
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct272
Distinct (%)9.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean64.28864938
Minimum0
Maximum373
Zeros34
Zeros (%)1.1%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-07-29T10:42:47.638114image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2
Q111
median31
Q381
95-th percentile242
Maximum373
Range373
Interquartile range (IQR)70

Descriptive statistics

Standard deviation77.75617089
Coefficient of variation (CV)1.209485215
Kurtosis2.778038567
Mean64.28864938
Median Absolute Deviation (MAD)26
Skewness1.798396863
Sum190873
Variance6046.022112
MonotonicityNot monotonic
2022-07-29T10:42:47.745150image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
199
 
3.3%
487
 
2.9%
285
 
2.9%
385
 
2.9%
876
 
2.6%
1067
 
2.3%
966
 
2.2%
766
 
2.2%
1764
 
2.2%
2255
 
1.9%
Other values (262)2219
74.7%
ValueCountFrequency (%)
034
 
1.1%
199
3.3%
285
2.9%
385
2.9%
487
2.9%
543
1.4%
766
2.2%
876
2.6%
966
2.2%
1067
2.3%
ValueCountFrequency (%)
3732
0.1%
3724
0.1%
3711
 
< 0.1%
3681
 
< 0.1%
3664
0.1%
3652
0.1%
3641
 
< 0.1%
3601
 
< 0.1%
3591
 
< 0.1%
3584
0.1%

qtde_invoices
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct56
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.72280229
Minimum1
Maximum206
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-07-29T10:42:47.862456image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median4
Q36
95-th percentile17
Maximum206
Range205
Interquartile range (IQR)4

Descriptive statistics

Standard deviation8.85665393
Coefficient of variation (CV)1.547607882
Kurtosis190.8253633
Mean5.72280229
Median Absolute Deviation (MAD)2
Skewness10.76645634
Sum16991
Variance78.44031883
MonotonicityNot monotonic
2022-07-29T10:42:47.972480image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2786
26.5%
3498
16.8%
4393
13.2%
5237
 
8.0%
1190
 
6.4%
6173
 
5.8%
7138
 
4.6%
898
 
3.3%
969
 
2.3%
1055
 
1.9%
Other values (46)332
11.2%
ValueCountFrequency (%)
1190
 
6.4%
2786
26.5%
3498
16.8%
4393
13.2%
5237
 
8.0%
6173
 
5.8%
7138
 
4.6%
898
 
3.3%
969
 
2.3%
1055
 
1.9%
ValueCountFrequency (%)
2061
< 0.1%
1991
< 0.1%
1241
< 0.1%
971
< 0.1%
912
0.1%
861
< 0.1%
721
< 0.1%
622
0.1%
601
< 0.1%
571
< 0.1%

qtde_items
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct1665
Distinct (%)56.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1606.461098
Minimum1
Maximum196844
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-07-29T10:42:48.093165image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile101.4
Q1296
median639
Q31399
95-th percentile4407.4
Maximum196844
Range196843
Interquartile range (IQR)1103

Descriptive statistics

Standard deviation5882.976527
Coefficient of variation (CV)3.6620722
Kurtosis467.153716
Mean1606.461098
Median Absolute Deviation (MAD)420
Skewness17.87844459
Sum4769583
Variance34609412.81
MonotonicityNot monotonic
2022-07-29T10:42:48.204190image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
31011
 
0.4%
889
 
0.3%
1509
 
0.3%
2608
 
0.3%
848
 
0.3%
2888
 
0.3%
2728
 
0.3%
2468
 
0.3%
5167
 
0.2%
3947
 
0.2%
Other values (1655)2886
97.2%
ValueCountFrequency (%)
11
< 0.1%
22
0.1%
122
0.1%
161
< 0.1%
171
< 0.1%
181
< 0.1%
191
< 0.1%
201
< 0.1%
231
< 0.1%
251
< 0.1%
ValueCountFrequency (%)
1968441
< 0.1%
809971
< 0.1%
799631
< 0.1%
773731
< 0.1%
699931
< 0.1%
645491
< 0.1%
641241
< 0.1%
628121
< 0.1%
582431
< 0.1%
577851
< 0.1%

qtde_products
Categorical

HIGH CARDINALITY
UNIFORM

Distinct2967
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Memory size23.3 KiB
2123221231
 
2
85123A217332173385123A
 
2
2068521524226914811648194481844818748173C82483824867147717091J7223272349B725861700322810228098248682483481872268771477
 
1
2173385123A21181218682153321080475662171482482224692247085099B475662285575049L85123A21080
 
1
230522305022766230532305121654220872267779030G23054230492305123053230502305223054226802268222683221702309222767230522305185123A221897281222676226792309222766230512165485032D84806B2305023052227662309290030A90030C22676226772267823323233272095623052
 
1
Other values (2962)
2962 

Length

Max length39930
Median length1493
Mean length623.7325699
Min length5

Characters and Unicode

Total characters1851862
Distinct characters33
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2965 ?
Unique (%)99.9%

Sample

1st row85123A7105384406B84029G84029E22752217302263322632226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522173085123A7105384406B206793737021871210712106882483824868248282494L84029G84029E2275221730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105382483824868248282494L2241184029G84029E227522280321730226322263337370218712107121068824832241184029G84029E217302275285123A71053226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E21730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263384029E22752228032173085123A7105384406B3737021871210712106882483824868248282494L2241184029G226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B373702187121071210688248282494L84029G84029E2275221730226332263285123A7105384406B15056BL2067937370210712106882483824868248282494L84029G84029E2275222803217302263222633
2nd row848792274522748227492231084969226232262221754217552177748187229602291322912229142175616161P227662270823231850158501622829227222296022961229692272022549209722274384969226222165821756217542175548184226922274822745227492296022722227202097222274849692262322499226072165847566217562175421755219022190121899219002207785123A2315223182231612316023163231622316423177231762300622996230702312623299849692165822423475662162123092231122311023111231182309323089231682323623240231752317323245230322303123029230288505322090220892208885123A217554756622423849692312620972227202315223162231632262316161P21754217552190121900481872311223111231102309323028232452324023173232362318223161231602296023546235452323122720227082298622739234352296022722227202097222621481884818448187230322303185053232452289922367235142351323511231982329423295230252347023397230962348723109234342208685049E
3rd row22728227272272621724218831000221791210352232622629226592263122661217312290021913225402254422492210862108022726227272272822729211212232620750225512255622555217312239022333223312071921883210422236721094225402253922556225542255121981226152261622614162182232622492230072301021559210422108021086210942124021731223332233122556225542272922197220902249222991230092328023281225562249222434212402123822090227292072420719210392112121212211542098320981212458438023100212402123821244212422329822197212102235622466226102260922561227262272722728227291621823124210942108021086215592233322728210802109421086229552263622556359702198821989219872255422551220812208222080212102115621080210862109423445223262316922326224922103921210226592272622727227282233322466233282338823389233902337323374229912173122778221972336823367235062350922629215592115620750220902329822539233892235223389233882339022197207242348023570233672255522951224172197620719207242235622492226362219722083223262232821207227272272622728227302344523298212122336723368223332299121094210862108021988219892198721680223322359823084235622254022544234802308423298229092261322617235152236721156223522155922326233882272822726
4th row22086228432284122839224232290722961225852208422423212322245722084233782312922423220772295023351233502331923354220868494622734229522301323012
5th row212582125821258

Common Values

ValueCountFrequency (%)
21232212312
 
0.1%
85123A217332173385123A2
 
0.1%
2068521524226914811648194481844818748173C82483824867147717091J7223272349B7258617003228102280982486824834818722687714771
 
< 0.1%
2173385123A21181218682153321080475662171482482224692247085099B475662285575049L85123A210801
 
< 0.1%
230522305022766230532305121654220872267779030G23054230492305123053230502305223054226802268222683221702309222767230522305185123A221897281222676226792309222766230512165485032D84806B2305023052227662309290030A90030C226762267722678233232332720956230521
 
< 0.1%
232052320185123A2198521212221782131422457229697274185169A211222112421986213858506621714213812249979302M847552241321181219772187021874226522283522112224082277985180B84510A22423227762197421671216722167021669216682208921381222952322720829848792247022670231472222485099F23201223862320021928219294819422469475662245785123A2072323204223562320522314700062240923472235312348423543849922121221985475662242385099B22376215772192821929207132238623201233432335684078A2244122169227682198321984233782308484978231732269822697231752269923382234802348923528235292352323527235422238522663233432334422809228102294222941850488494571477233131
 
< 0.1%
2234922301223002274922606226202260722605229982289922904227412275220977228212238420728227282273022969229932290722905226652238423209222732096920970221502214771477219122322922605225702256823119224932097220971227582275422752219352193422382232062072722383229612179122570225692215022147209722096922564225632274120727232092072522667232752214922607219142191522605226932275922562226322263323439228662286522867234932350423503229402214222141221442173123084225542255522557225682096920970209722097122632226332343922866228652286722112228352320923198226662315822940230822308323100232672338923480230842256822621209692097023493234942335522114228352211235970231002308321914228652286722556225542255723493234802173123084221122283523355230831
 
< 0.1%
710532208722087213401
 
< 0.1%
2250122776213404813871459847552242722844224234756622382223842238685099C2072585099B229072129423173226992317023245227202238422386224234756685123A2324323174231752243023582223868248690058B85099C23344900571
 
< 0.1%
217032304823044209722274922568227512304323044230911
 
< 0.1%
Other values (2957)2957
99.6%

Length

2022-07-29T10:42:48.341330image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
charges6
 
0.2%
21232212312
 
0.1%
85123a217332173385123a2
 
0.1%
2248775013b85123a8248375013b2276672802a72807a20828224878248422171824838248685213228002279172351b207672280622170213132245785123a82494l170032312010133207732076820774230822306582482101352082882494l725862248820828101352245722185824838248272351a217142171323462227682188922560224892191410135170032261922440233562148535471d221122262182494l8248272351b8248382483210341
 
< 0.1%
221398485422411825672167222774227717127022262226372193421169211662117537444a37444c220862208384971s7127047580222618483222644215332155715056bl15056n226462217622438217312277822719215232262022778849462103384865211722150484563a84563b2250221867216722167337444a2277585035b22775843782263722891218992208382613b82599211582208685014a374462235521258793213744935004c84559b84997d4758084415b2065522170206772123922088220902090622262221752217621243220832109837444b2193422646373332121221872212598486584997d22086226208497884050212582290984997d84997c212442067521240215592289184946226444758021470227882276622261222622156372598225028248615056bl7932135004c82494l225022082922778228442264421731228452173185184c227742290922910824864000115056n228342075022788208292177421231207192072685035b793212080248173c2075082567848362167084849d229092284522746225632256222756219492124321245206772067484997d84997c84997b826002272321832223132244585136a7932148111222422271985099b35004c21668793212208721258221982217184997d84997c824838248615056bl84563a22891215592156121558223522165884509a2173121169223842209047580217732252385036a21988219892089782613c21899848322138021670216692167121672216732226221445214472143920675826002075020829223252156321564211212277521380222412177437449217732237821240212382106884970l84970s84989a2115521243212442124522909206752067422620207332112175049l8475521672216718248484947849468515284997c84997a84997d228052277121931223558248485099f2117582599207252072722384207282071920718207242067720675206742067684997b212422210384993a21244212432124521240212392123820676212122277422775227732277222845228442257182001s207272271921774218818248221754211642280521242206762108021212212388483621121218442264584970s15056n215582103521041475802075420718207242235615056n35004c79321227782284521658843782067622352216712167321669216702167284997d84997c2072521240210682123121210210802198921242212442124521243211232175485099f2071321930219282241121934217732072521668227742167021669216712167321754218992124321244220888259984997b84997d84997c84997a84509a84510a222622184472799f206752067720674206762156185099c85099f2071922356217312284437448221972206185232a2241184520b22088215592155884997c2165822494212442124521033215592156121558206752175485099b84997b84997d2217572760b2112222494215632156484997c84997a216732167221671216702166922774217312193415056n224942247021329213282132722262227752277421669216702290822908219892250279321215232208784509c84946213132067915056n222622217084970s22171474214742222470213272263722325227882082922313217332252185032b2138085019a2186721867214392289185163b1601621755848652155785167b848322211247559b4758021035848368437821658219472194921899215632156417136a2112121122206653733321166211698258182567825832227822276211632115984912b214702146784849d84971s84997c84997a2208922090220882075084596b84596f22176216732116421987219892068522646207282210321564217332112184378222622061884949211758515285014a15056n85014b851502155672760b84559b227522224185163b221712215122152221752231822170222472189984971s2167321672216712167020750215572277222241848368518722361223632236421122222622216272760b8520085150825992116915056bl15056n2217622318222428497822778227752166922774824862192820713207122193137444b37444a84849d2226222620851872145647590a2231885205b35920848362138917136a84997a22284215638248322121359242117584949227732155884849d2194784912a15056bl15056n219302211222291222762082985185b2216235637a215633592185163b85099c223522193121673226452072522087359242145615056n217552167222771228052228485205b21380226372226284997a84997d20829219492241147580215638483285188a223552217184509a22772216712167285185b2072684849d84832222812277020733211662132784510a2065585188a21470211102144522090208292235215056n222412175584865213292116985071d82567214702208621121219472188320655213802226220665210352192921928224112166821754400012071922719228442072479321216692072585099b2072784946212402067521244210332193182001s85099b82482213138497821314226632241122385222812111022613220882290822805227732175515056n825832082947590a2066585071d85071a84849d224182242084563a2147072799f8248421240215232067721243212442067521239211652116637444c37444a84750b84849d2198721121211222153782613a851872228184997a226632224182583824868248372760b79321212388497822364228452224175049l4742147590a2277122805206552123922325222628248384997a223182278815056n85014a21470215592217120725219312072622355216682208717129f21080215234818721558216722167021673216692271922774227722217122170213862229121169217312262085232a21755219342228185150211692143921380220902208922088225258518782483213142131385099b2193622101207282131375049l2121848173c4818548111481162124222197714598497822087824838248622104848328494621989225258515221755213802173320829206658437821035215578258184912a2209022321224112103385188a22291359212275221389215632156422771228052208782494l218844758021563215642252120829213802246722778849782271917129f219313744621035214702116622089225232065584997a85200213892229122525225582275522758227562275322754227578494982613c2138085188a215642275822757227562275522754227532198722243826002208885205b21171224112319923201232052320422661232052320823206851972228115056p2145921212216692167122355712792195582001s85099b2277522355223562072320724223832072622382223842072520727207282241121929226632193020711223852103321928223862193120712211758515222670231822267122672226752267422673850532245715056n15056p2144784563a2227882613a206558494922637226202262021731223322233122333223342209022089220882208722908213272132922281847892101221564220872075021928219292241120750221752156484997a221622215184949208292213922457219342319923201851522117584832226202186485014b15056bl15056n2208821931223844000320676206742072775049l84755849787145922386207122241185099f85099b227782167321672216702166921668217922266321211219882279620750218992140884997d21380227662217584997a21731231402314121115217332156321564211662116482600232564758015056n15056bl21557226372213921033223852192822457849782316885099b2193020711224272238685099f21931207192071221929226612238322382207182308484997c2319223191231902316523167231662237946138b2320621559221522156346138b232062241122178219312213921929223862266385099c85099f22386207122237921175712702186747590b22766226612071923208475802238315056n207282082920726207242072322356212452124284997a84997b232052320885099f22386207122192985099c84510a2320422383232012209084509a85099c23208231992238621929207272071220718228962071923205207262072385099f2325622382207282238422139216702308415056bl2275284692227572275822756232052235620724207232072620725219292103385099f85099b8497875049l17129f8248422774227722277121314227782316815056bl15056n84849d82613d826002227884997a84997c71270712702115922663211692275221467211152143984997b84997d22891227582155784970s20829213802173122382220832111548194226612072722663207192303423035230332242722103714772238217129f82001s20685232042071923206207282319923201224112238685099b21928219312189984596b84596f2111521166215562117121163213802173115056n15056bl22083826002156484347212312208321559224112193185099c2308923084217311600882001s21137227552275621787214472204121175211792116923182211942120815056n2067921557223162319247590a211242319623197231982242622278223158505384596f2328523286232872328818097c228912235447559b47580231992266385099b17091j2257122572210332238647590a2156321557227522111082613d17091j15056n206792173123201223852316623165231632242623182226712303520829220452167322548217902267022409224072240622408224072217921980219832198522615224682198221984219672261647310m2071221137160084811185159a85159b219302071185014b82613d22671208292121120898218672275622753227582275722754227552262022139231822215121447212328248622905229042290323197162252319223190229082178747351b2238675049l223602303322426230352308921716217152277371477227732277422041217182142821672216692290816225224672066584347229052116922671231822319823196231971600885014b15056n15056bl21671216682152348187231682303484569a84569d15056bl15056n20711219302071282600207262072421669216682167121670216722310417129f2113722467824862124585099f2192922775232062238322384207271600821731231822319647310m208292113721718217152318222316227552240923166231672319823197223152231615056bl71459207331600815056n15056bl22316231822277547310m22178231672267084970l2221922139214242142623198231962319723198217542240622409219862179121790226702178721930223862319985099c226702198222409217872247648173c15056bl22755211372131347310m82001s2316822197220412231648173c15056bl15056n85099b2267523201225482318272802a2213547351b1600823198712702121021424214272142822406217182171621467231672308922315223642277817129f213137147775049l8497847351b23168231652284482001s21137160082275215056bl15056n22620217552175448173c21934226372308922409214302240722408224104748047471217312267022665221512275722756227582275322754227552319823197231962267221447208292217421428228918256782600211752267521425214272290422905229032179021791225482254916225224062171822560222972198721439218672065584997d84997c84997a84997b221392293922990214702070479302m21989217152171622134231542210148173c221782235221470216692277385099c2316723166223862071322674226752232622328223272232922410227552233322411207122193021929219342267522670226732267415056n15056bl2303123029230322302822758217872082922646226452318446118214282217922326227212236223403219282192922663207112241121930207122217322682226832268022681226842268522670226792268622677226712267222673226782267684406b2314723146231482082922427227582232684949221322213379066k2318247563a84912a221398483220655213292189921327224292194723016215312264422637221792116621867209862250085014b85014a213802275221684231842153023142228982289921523230892242715056bl21791222162179022904230361622522644226462192920711211662227822674226912269222414223652236685014a206792316921110850531622523190231922319122754226202278144089c44089a8434721327213292231822085226712290421380226282257185099b79066k2238621928475802268622685226812233122406843472266321561215592113720713233152331623317214272241023026231632189222310215302264422646232752264522757219342268321427212573592422227231972275522686226852267622671218822188022326214702303184970l2120721166211652232715056bl8434784510a208292213984509a2316822467231662316585159b217747145948184231692208385099c22411207122268622676226702267722679226812302923032227582327522409218122318221086223322233315056n15056bl16008226632193421121226802267623032221712267715056p2331622366226202231085014b2132921791213272117422326227582198721881223312227621530227562188221812218112186421866230312275722162475802233222333212574818479302m4818522678226832314715056bl2173122326232752303122677226862268023148222972290521232217902236684600215302303221811227552213917091j211372121022686226782268322682226762267722685212588460084510a23275226208434715056bl208292267421731222278494784347215582314822663215302275821012229042213921094207132246822905226792275822755230322217521530224262104184510a23147226718434715056bl21755215312263722386219342319622758222272155822904843752173122161226822267722678843472240723169224672125884947211372275522758231682327548173c849472242616008225562319722572225712213921879218832188121880226202193422426229622296322227221392314716008843478248684510a22753227572138015056bl15056n23031231462241115056n15056bl21773227572181122904229052290322227226852268222683226782267622671226772268022670226812268422686226792267222754227562275322673226752267423163160082318222310211212188384375231462186722175851502116421169851522117521530224682217921211211642198821557226204742120679220652296322962211372316823166231672238620712227782213922844219342193021929219282131375049l84945847924811182483824822266385099c224112217182001s217312143915056p21987843472206582486206852222723271223332115947559b2082923397481872181184347218922314821812220782101222227223652242623168207112179122152215302275422753227562275723317233152250072800e160082184422227231962318422310217872267421880218822192822663221792082921892843752242920712220832316922467725982222735001g211101601621949218998483684347211694811684970s2067979302m8505321012233972236547563a21470214282082923026232752238685099c224114818821169207182072485099b223278469223031213808520285204852032319784347233162331522265207132279415056bl2204121169843472278123315233162275584971s442354423444235227582275523197226912113721258224142152448116231692331523316233172179022678222622189222227217182171623184231962193185099b84347224108494523147231482240647310m79302m229054611884978227522125823326213134818723317231972101222227227942318221755850532311021169212582316823167213142113744234843471
 
< 0.1%
22297227712277222773228052246922197211252112685049c85049d85049e85049g21061210632106284380843782296421213224172121284992219752238320728207272229620728207252072722383223842123222646223182072720728223832238423209207252264622645212312123223089231472314682486221972265022644224692219722469207272072822383232092193185099c2320385099b2192821929824868248385130b85130c20725223842358323301223832320922469226502219723096234522345322297207251
 
< 0.1%
22086229102283722730227278248484050226054811148188206852152322278217418517437343229042153121533210682107121523847542298522983226492153922072214982149921527374482224522693847552282722030232322323122501229262250222241229572228722699219222235422721226662292684879224422244322441212012290421218214072111622730227272260522697226982269922502225012242382484218447932121187475662111421925226912121021094210802108622333220902208722088220842208321202212042296475049l84380224372120721215231092229722927224432244121114231082260721917206852329823173226992269822697227252273022729227282272723283224568248485123a22501220372320823209232032320223046231702316821094220902208822083212122108621201212042120622197212132300022999226242272623244232352324521922225052272922728227252273022727793212242322781226052320822441224432269722699232452269885049g2317384755359702310122603226022321323209231122245622767227688248622766219168248479321219222290422026220302150622983226522317023175231742242722191227262272922730230572229622297227412256122083224182219723190210802299923000220902108621094217542111422725227272269922697226242260522441232088248322766227672320922698227262324521497232327147723075230462307022792230662306521916224568248422191227212266522666214072316885123a2317323109233502339323395234122335622467232432284322841235592269323196231972150622983229852354623545793212242382484714772323223109230702328323462233562266622665226052219121497217542245623112226992269823172231712317022727227262331122732233192208623381219802337922114233562335584029g235032300022999224361
 
< 0.1%
2211022098221002276622451225498474485049e213282296117091a2247384509a84510a22767227682146321464208208515022117211694812982580825788258122413219072244121122228518499122810228092243520966209632096122068217432174484709b2159221587209922266285123a228048248320749207252238220726223842246784625c84625a21108228482103347570b84030e22428225021621884559b84559a22437224368522722983220302119921829212942233222181222712227421989230532305216259475662329821034223542132640001851072332223321233332333423332224602298323109230822103423177851771623621703210982299723501235042350222621227552183223188230842207485049c1622585123a2214422910207582343423435233112340622766227282335282616c23044224912339523393233942278523569235702357184029g21479233192331884012235312278123486210341
 
< 0.1%
227282272722726217242188310002217912103522326226292265922631226612173122900219132254022544224922108621080227262272722728227292112122326207502255122556225552173122390223332233120719218832104222367210942254022539225562255422551219812261522616226141621822326224922300723010215592104221080210862109421240217312233322331225562255422729221972209022492229912300923280232812255622492224342124021238220902272920724207192103921121212122115420983209812124584380231002124021238212442124223298221972121022356224662261022609225612272622727227282272916218231242109421080210862155922333227282108021094210862295522636225563597021988219892198722554225512208122082220802121021156210802108621094234452232623169223262249221039212102265922726227272272822333224662332823388233892339023373233742299121731227782219723368233672350623509226292155921156207502209023298225392338922352233892338823390221972072423480235702336722555229512241721976207192072422356224922263622197220832232622328212072272722726227282273023445232982121223367233682233322991210942108621080219882198921987216802233223598230842356222540225442348023084232982290922613226172351522367211562235221559223262338822728227261
 
< 0.1%
220862284322841228392242322907229612258522084224232123222457220842337823129224232207722950233512335023319233542208684946227342295223013230121
 
< 0.1%
Other values (2963)2963
99.4%

Most occurring characters

ValueCountFrequency (%)
2568777
30.7%
1193850
 
10.5%
3182049
 
9.8%
8140316
 
7.6%
9133911
 
7.2%
0129867
 
7.0%
4125320
 
6.8%
7121703
 
6.6%
5121128
 
6.5%
6104084
 
5.6%
Other values (23)30857
 
1.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number1821005
98.3%
Uppercase Letter30846
 
1.7%
Space Separator11
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
B8451
27.4%
A7546
24.5%
C3827
12.4%
D2101
 
6.8%
L1834
 
5.9%
E1419
 
4.6%
F1252
 
4.1%
S1160
 
3.8%
G991
 
3.2%
P565
 
1.8%
Other values (12)1700
 
5.5%
Decimal Number
ValueCountFrequency (%)
2568777
31.2%
1193850
 
10.6%
3182049
 
10.0%
8140316
 
7.7%
9133911
 
7.4%
0129867
 
7.1%
4125320
 
6.9%
7121703
 
6.7%
5121128
 
6.7%
6104084
 
5.7%
Space Separator
ValueCountFrequency (%)
11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common1821016
98.3%
Latin30846
 
1.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
B8451
27.4%
A7546
24.5%
C3827
12.4%
D2101
 
6.8%
L1834
 
5.9%
E1419
 
4.6%
F1252
 
4.1%
S1160
 
3.8%
G991
 
3.2%
P565
 
1.8%
Other values (12)1700
 
5.5%
Common
ValueCountFrequency (%)
2568777
31.2%
1193850
 
10.6%
3182049
 
10.0%
8140316
 
7.7%
9133911
 
7.4%
0129867
 
7.1%
4125320
 
6.9%
7121703
 
6.7%
5121128
 
6.7%
6104084
 
5.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII1851862
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2568777
30.7%
1193850
 
10.5%
3182049
 
9.8%
8140316
 
7.6%
9133911
 
7.2%
0129867
 
7.0%
4125320
 
6.8%
7121703
 
6.6%
5121128
 
6.5%
6104084
 
5.6%
Other values (23)30857
 
1.7%

avg_ticket
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct2966
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean51.90005685
Minimum2.150588235
Maximum56157.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-07-29T10:42:48.450347image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Quantile statistics

Minimum2.150588235
5-th percentile4.916661099
Q113.11933333
median17.97438356
Q324.98828571
95-th percentile90.497
Maximum56157.5
Range56155.34941
Interquartile range (IQR)11.86895238

Descriptive statistics

Standard deviation1036.934336
Coefficient of variation (CV)19.9794451
Kurtosis2890.70744
Mean51.90005685
Median Absolute Deviation (MAD)5.994222271
Skewness53.4442279
Sum154091.2688
Variance1075232.818
MonotonicityNot monotonic
2022-07-29T10:42:48.545381image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
152
 
0.1%
4.1622
 
0.1%
14.478333332
 
0.1%
18.152222221
 
< 0.1%
13.927368421
 
< 0.1%
36.244117651
 
< 0.1%
29.784166671
 
< 0.1%
22.87926231
 
< 0.1%
20.511041671
 
< 0.1%
149.0251
 
< 0.1%
Other values (2956)2956
99.6%
ValueCountFrequency (%)
2.1505882351
< 0.1%
2.43251
< 0.1%
2.4623711341
< 0.1%
2.5112413791
< 0.1%
2.5153333331
< 0.1%
2.651
< 0.1%
2.6569318181
< 0.1%
2.7075982531
< 0.1%
2.7606215721
< 0.1%
2.7704641911
< 0.1%
ValueCountFrequency (%)
56157.51
< 0.1%
4453.431
< 0.1%
3202.921
< 0.1%
1687.21
< 0.1%
952.98751
< 0.1%
872.131
< 0.1%
841.02144931
< 0.1%
651.16833331
< 0.1%
6401
< 0.1%
624.41
< 0.1%

avg_recency_days
Categorical

HIGH CARDINALITY

Distinct290
Distinct (%)9.8%
Missing0
Missing (%)0.0%
Memory size23.3 KiB
35 days
 
49
14 days
 
45
46 days
 
43
21 days
 
43
22 days
 
43
Other values (285)
2746 

Length

Max length8
Median length7
Mean length7.127989222
Min length6

Characters and Unicode

Total characters21163
Distinct characters15
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique67 ?
Unique (%)2.3%

Sample

1st row35 days
2nd row27 days
3rd row23 days
4th row92 days
5th row8 days

Common Values

ValueCountFrequency (%)
35 days49
 
1.7%
14 days45
 
1.5%
46 days43
 
1.4%
21 days43
 
1.4%
22 days43
 
1.4%
38 days42
 
1.4%
17 days41
 
1.4%
27 days41
 
1.4%
28 days41
 
1.4%
26 days41
 
1.4%
Other values (280)2540
85.6%

Length

2022-07-29T10:42:48.645398image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
days2969
50.0%
3549
 
0.8%
1445
 
0.8%
4643
 
0.7%
2143
 
0.7%
2243
 
0.7%
3842
 
0.7%
1741
 
0.7%
2741
 
0.7%
2841
 
0.7%
Other values (281)2581
43.5%

Most occurring characters

ValueCountFrequency (%)
2969
14.0%
d2969
14.0%
a2969
14.0%
y2969
14.0%
s2969
14.0%
11181
 
5.6%
2861
 
4.1%
3715
 
3.4%
4651
 
3.1%
5633
 
3.0%
Other values (5)2277
10.8%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter11876
56.1%
Decimal Number6318
29.9%
Space Separator2969
 
14.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
11181
18.7%
2861
13.6%
3715
11.3%
4651
10.3%
5633
10.0%
6513
8.1%
7505
8.0%
9437
 
6.9%
8429
 
6.8%
0393
 
6.2%
Lowercase Letter
ValueCountFrequency (%)
d2969
25.0%
a2969
25.0%
y2969
25.0%
s2969
25.0%
Space Separator
ValueCountFrequency (%)
2969
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin11876
56.1%
Common9287
43.9%

Most frequent character per script

Common
ValueCountFrequency (%)
2969
32.0%
11181
 
12.7%
2861
 
9.3%
3715
 
7.7%
4651
 
7.0%
5633
 
6.8%
6513
 
5.5%
7505
 
5.4%
9437
 
4.7%
8429
 
4.6%
Latin
ValueCountFrequency (%)
d2969
25.0%
a2969
25.0%
y2969
25.0%
s2969
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII21163
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2969
14.0%
d2969
14.0%
a2969
14.0%
y2969
14.0%
s2969
14.0%
11181
 
5.6%
2861
 
4.1%
3715
 
3.4%
4651
 
3.1%
5633
 
3.0%
Other values (5)2277
10.8%

frequency
Real number (ℝ≥0)

Distinct1345
Distinct (%)45.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.07534240692
Minimum0.005464480874
Maximum6
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-07-29T10:42:48.742425image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Quantile statistics

Minimum0.005464480874
5-th percentile0.009469702633
Q10.01785714286
median0.02949852507
Q30.05555555556
95-th percentile0.2393929539
Maximum6
Range5.994535519
Interquartile range (IQR)0.0376984127

Descriptive statistics

Standard deviation0.2313970644
Coefficient of variation (CV)3.071272526
Kurtosis217.4065284
Mean0.07534240692
Median Absolute Deviation (MAD)0.01446093109
Skewness12.28158046
Sum223.6916062
Variance0.05354460142
MonotonicityNot monotonic
2022-07-29T10:42:48.841442image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.142857142921
 
0.7%
0.333333333319
 
0.6%
0.518
 
0.6%
0.0714285714317
 
0.6%
0.0322580645216
 
0.5%
0.0285714285715
 
0.5%
0.181818181815
 
0.5%
0.0952380952415
 
0.5%
0.0476190476215
 
0.5%
0.415
 
0.5%
Other values (1335)2803
94.4%
ValueCountFrequency (%)
0.0054644808741
 
< 0.1%
0.0054794520551
 
< 0.1%
0.0055096418731
 
< 0.1%
0.0055248618781
 
< 0.1%
0.0056022408962
0.1%
0.0056179775281
 
< 0.1%
0.0056338028172
0.1%
0.0056818181821
 
< 0.1%
0.0056980056982
0.1%
0.0057142857143
0.1%
ValueCountFrequency (%)
61
 
< 0.1%
41
 
< 0.1%
33
 
0.1%
211
0.4%
1.8333333331
 
< 0.1%
1.51
 
< 0.1%
1.3333333332
 
0.1%
114
0.5%
0.751
 
< 0.1%
0.666666666712
0.4%

qtde_returns
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct214
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean62.1569552
Minimum0
Maximum80995
Zeros1481
Zeros (%)49.9%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-07-29T10:42:48.948461image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q39
95-th percentile100.6
Maximum80995
Range80995
Interquartile range (IQR)9

Descriptive statistics

Standard deviation1512.496135
Coefficient of variation (CV)24.33349783
Kurtosis2765.52864
Mean62.1569552
Median Absolute Deviation (MAD)1
Skewness51.79774426
Sum184544
Variance2287644.557
MonotonicityNot monotonic
2022-07-29T10:42:49.065490image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
01481
49.9%
1164
 
5.5%
2148
 
5.0%
3105
 
3.5%
489
 
3.0%
678
 
2.6%
561
 
2.1%
1251
 
1.7%
843
 
1.4%
743
 
1.4%
Other values (204)706
23.8%
ValueCountFrequency (%)
01481
49.9%
1164
 
5.5%
2148
 
5.0%
3105
 
3.5%
489
 
3.0%
561
 
2.1%
678
 
2.6%
743
 
1.4%
843
 
1.4%
941
 
1.4%
ValueCountFrequency (%)
809951
< 0.1%
90141
< 0.1%
80041
< 0.1%
44271
< 0.1%
37681
< 0.1%
33321
< 0.1%
28781
< 0.1%
20221
< 0.1%
20121
< 0.1%
17761
< 0.1%

avg_basket_size
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct1973
Distinct (%)66.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean249.349541
Minimum1
Maximum40498.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-07-29T10:42:49.195616image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile44
Q1103.25
median172
Q3281.5
95-th percentile599.52
Maximum40498.5
Range40497.5
Interquartile range (IQR)178.25

Descriptive statistics

Standard deviation791.5024106
Coefficient of variation (CV)3.174268569
Kurtosis2256.245507
Mean249.349541
Median Absolute Deviation (MAD)82.75
Skewness44.68328098
Sum740318.7873
Variance626476.066
MonotonicityNot monotonic
2022-07-29T10:42:49.313152image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10011
 
0.4%
11410
 
0.3%
739
 
0.3%
869
 
0.3%
829
 
0.3%
1368
 
0.3%
608
 
0.3%
758
 
0.3%
888
 
0.3%
717
 
0.2%
Other values (1963)2882
97.1%
ValueCountFrequency (%)
12
0.1%
21
< 0.1%
3.3333333331
< 0.1%
5.3333333331
< 0.1%
5.6666666671
< 0.1%
6.1428571431
< 0.1%
7.51
< 0.1%
91
< 0.1%
9.51
< 0.1%
111
< 0.1%
ValueCountFrequency (%)
40498.51
< 0.1%
6009.3333331
< 0.1%
42821
< 0.1%
39061
< 0.1%
3868.651
< 0.1%
28801
< 0.1%
28011
< 0.1%
2733.9444441
< 0.1%
2518.7692311
< 0.1%
2160.3333331
< 0.1%

avg_unique_basket_size
Real number (ℝ≥0)

HIGH CORRELATION

Distinct1010
Distinct (%)34.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.15507374
Minimum1
Maximum299.7058824
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-07-29T10:42:49.434838image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.345454545
Q110
median17.2
Q327.75
95-th percentile56.94
Maximum299.7058824
Range298.7058824
Interquartile range (IQR)17.75

Descriptive statistics

Standard deviation19.51303316
Coefficient of variation (CV)0.8807478316
Kurtosis27.69469772
Mean22.15507374
Median Absolute Deviation (MAD)8.2
Skewness3.498252107
Sum65778.41393
Variance380.7584629
MonotonicityNot monotonic
2022-07-29T10:42:49.535861image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1353
 
1.8%
1440
 
1.3%
1138
 
1.3%
2033
 
1.1%
933
 
1.1%
132
 
1.1%
1831
 
1.0%
1030
 
1.0%
1629
 
1.0%
1728
 
0.9%
Other values (1000)2622
88.3%
ValueCountFrequency (%)
132
1.1%
1.21
 
< 0.1%
1.251
 
< 0.1%
1.3333333332
 
0.1%
1.58
 
0.3%
1.5681818181
 
< 0.1%
1.5714285711
 
< 0.1%
1.6666666674
 
0.1%
1.8333333331
 
< 0.1%
224
0.8%
ValueCountFrequency (%)
299.70588241
< 0.1%
2591
< 0.1%
203.51
< 0.1%
1481
< 0.1%
1451
< 0.1%
136.1251
< 0.1%
135.51
< 0.1%
1271
< 0.1%
1221
< 0.1%
1181
< 0.1%

Interactions

2022-07-29T10:42:45.412849image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:33.503049image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:34.579725image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:36.355273image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:37.388283image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:38.450871image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:39.476634image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:40.774647image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:41.878779image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:42.934665image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:44.062300image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:45.509871image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:33.608071image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:34.685805image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:36.448293image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:37.484997image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:38.539889image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:39.758979image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:40.877182image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:41.977803image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:43.033338image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:44.160320image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:45.608898image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:33.703094image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:34.778821image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:36.536313image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:37.577747image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:38.628913image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:39.856726image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:40.978855image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:42.077824image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:43.130358image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:44.259342image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:45.700925image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:33.802118image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:34.878842image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:36.626335image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:37.667754image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:38.720933image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:39.953742image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:41.071129image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:42.168396image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:43.230397image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:44.356366image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:45.798939image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:33.904136image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:35.660477image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:36.719368image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:37.767345image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:38.824959image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:40.053764image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:41.166149image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:42.263410image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:43.334407image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:44.463389image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:45.886972image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:33.992157image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:35.750190image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:36.806375image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:37.859366image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:38.913979image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:40.150327image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:41.258827image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:42.354775image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:43.435445image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:44.564922image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:46.002986image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:34.096811image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:35.853457image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:36.906446image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:37.966039image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:39.013000image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:40.256347image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:41.367845image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:42.455797image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:43.541452image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:44.912999image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:46.118016image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:34.187816image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:35.957480image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:37.000468image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:38.056059image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:39.102553image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:40.350654image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:41.463867image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:42.551052image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:43.640475image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:45.009019image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:46.231036image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:34.282839image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:36.056400image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:37.092493image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:38.149080image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:39.195570image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:40.450684image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:41.567070image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:42.641076image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:43.738583image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:45.107114image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:46.338068image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:34.380868image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:36.161424image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:37.194238image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:38.247110image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:39.291585image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:40.558697image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:41.675097image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:42.744186image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:43.846606image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:45.211147image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:46.443091image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:34.485691image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:36.262455image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:37.293276image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:38.355378image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:39.385607image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:40.666612image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:41.782758image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:42.842641image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:43.953275image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
2022-07-29T10:42:45.314827image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Correlations

2022-07-29T10:42:49.627881image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
2022-07-29T10:42:50.080245image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
2022-07-29T10:42:50.211684image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
2022-07-29T10:42:50.343896image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

2022-07-29T10:42:46.599125image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
A simple visualization of nullity by column.
2022-07-29T10:42:46.807978image/svg+xmlMatplotlib v3.5.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

First rows

df_indexcustomer_idgross_revenuerecency_daysqtde_invoicesqtde_itemsqtde_productsavg_ticketavg_recency_daysfrequencyqtde_returnsavg_basket_sizeavg_unique_basket_size
00178505391.21372.034.01733.085123A7105384406B84029G84029E22752217302263322632226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522173085123A7105384406B206793737021871210712106882483824868248282494L84029G84029E2275221730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105382483824868248282494L2241184029G84029E227522280321730226322263337370218712107121068824832241184029G84029E217302275285123A71053226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E21730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263384029E22752228032173085123A7105384406B3737021871210712106882483824868248282494L2241184029G226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B373702187121071210688248282494L84029G84029E2275221730226332263285123A7105384406B15056BL2067937370210712106882483824868248282494L84029G84029E227522280321730226322263318.15222235 days0.49295840.050.9705888.735294
11130473232.5956.09.01390.0848792274522748227492231084969226232262221754217552177748187229602291322912229142175616161P227662270823231850158501622829227222296022961229692272022549209722274384969226222165821756217542175548184226922274822745227492296022722227202097222274849692262322499226072165847566217562175421755219022190121899219002207785123A2315223182231612316023163231622316423177231762300622996230702312623299849692165822423475662162123092231122311023111231182309323089231682323623240231752317323245230322303123029230288505322090220892208885123A217554756622423849692312620972227202315223162231632262316161P21754217552190121900481872311223111231102309323028232452324023173232362318223161231602296023546235452323122720227082298622739234352296022722227202097222621481884818448187230322303185053232452289922367235142351323511231982329423295230252347023397230962348723109234342208685049E18.90403527 days0.04893035.0154.44444419.000000
22125836705.382.015.05028.02272822727227262172421883100022179121035223262262922659226312266121731229002191322540225442249221086210802272622727227282272921121223262075022551225562255521731223902233322331207192188321042223672109422540225392255622554225512198122615226162261416218223262249223007230102155921042210802108621094212402173122333223312255622554227292219722090224922299123009232802328122556224922243421240212382209022729207242071921039211212121221154209832098121245843802310021240212382124421242232982219721210223562246622610226092256122726227272272822729162182312421094210802108621559223332272821080210942108622955226362255635970219882198921987225542255122081220822208021210211562108021086210942344522326231692232622492210392121022659227262272722728223332246623328233882338923390233732337422991217312277822197233682336723506235092262921559211562075022090232982253923389223522338923388233902219720724234802357023367225552295122417219762071920724223562249222636221972208322326223282120722727227262272822730234452329821212233672336822333229912109421086210802198821989219872168022332235982308423562225402254423480230842329822909226132261723515223672115622352215592232623388227282272628.90250023 days0.04582250.0335.20000015.466667
3313748948.2595.05.0439.02208622843228412283922423229072296122585220842242321232224572208423378231292242322077229502335123350233192335422086849462273422952230132301233.86607192 days0.0179860.087.8000005.600000
4415100876.00333.03.080.0212582125821258292.0000008 days0.13953522.026.6666671.000000
55152914623.3025.014.02102.022114217338248482486217542242422505227682175421755217562217084406B848792113685066227962229422487481884819420685847552162121623229682275922762217564818882486222412228848185215242242482486222192217084406B221732218948138481942152448111212322125984970L22855222122224121756206858248646000S222198487922189228222152348188847557147784970L2278421673216722166921668228442285222845228534818482486216722175421755216682166921670217552167021669216682257822579225772152448188217332175421755221122257722578225792278422212222192335545.32647123 days0.05459829.0150.1428577.285714
66146885630.877.021.03621.02238685099C210332072384997B84997C210942072521559223522121221975219778499184519A85183B85071B219312192922343223452234484519A48188223792238185099B2108021086219758499221210219742266784519B212162193521934219002191184849D2096671496B71495B2186521867219012186647310M218642186722090793212238122379219754811148173C2237921934223802235621900219012190222197207232072420719223552299622995229982299779302M7932147310M2237922381223802209021212461182193221937206752067621901219252193421935216212205348111223862072377101A2235677101A2143046126A2123921240212382124277101A22197210942198979321221792295320724223554611821937219362117248188231822318221034223812237948188219342197479026B22997229952189921900219022190123182219362123821866218642186521867217702117220676206772067579051A47310M2217922995229972318247310M220908482823298793212238023204229532193422356216212116521936211722235523205231822190282551825522267447310M22090793212193521934219372193621936219312238623199229532071923204217702320523182825512299622355223562177023199232012237979321215592072721930219342238685099B210332238622995229982238420728231822318222197211622116323321230802193021931223862320185099C85099F85099B231992238021934219352071920723223552320522356232042072420727207252238447310M21430793212117223321219012190021899219022295322997215582177022379219348255121935207112237921770231824611822995224672334822138217702299647310M2142722674221382261722379223812334820711221382334822467223812348523328217422246722467217702330120728231692358316258A8255221949231942324147310M23471218992190021901235011623621832162372355220986235712249123126231272227422475221912098285135C85136A229972213821430231922318221754217562193023581223812237917.21978618 days0.073770399.0172.42857115.571429
77178095411.9116.012.02057.0229612294322617225692256884032B84032A22749229402290922652229102258521523226242152322624481382328423298229882236621463214642233421034223331012016235224392191421220213292097421829232842338222909229502291022141221422331222585229612256123188229912299223192846922330084347843472330023188221422214123298223662330088.71983635 days0.03921641.0171.4166675.083333
881531160767.900.091.038194.0221398485422411825672167222774227717127022262226372193421169211662117537444A37444C220862208384971S7127047580222618483222644215332155715056BL15056N226462217622438217312277822719215232262022778849462103384865211722150484563A84563B2250221867216722167337444A2277585035B22775843782263722891218992208382613B82599211582208685014A374462235521258793213744935004C84559B84997D4758084415B2065522170206772123922088220902090622262221752217621243220832109837444B2193422646373332121221872212598486584997D22086226208497884050212582290984997D84997C212442067521240215592289184946226444758021470227882276622261222622156372598225028248615056BL7932135004C82494L225022082922778228442264421731228452173185184C227742290922910824864000115056N228342075022788208292177421231207192072685035B793212080248173C2075082567848362167084849D229092284522746225632256222756219492124321245206772067484997D84997C84997B826002272321832223132244585136A7932148111222422271985099B35004C21668793212208721258221982217184997D84997C824838248615056BL84563A22891215592156121558223522165884509A2173121169223842209047580217732252385036A21988219892089782613C21899848322138021670216692167121672216732226221445214472143920675826002075020829223252156321564211212277521380222412177437449217732237821240212382106884970L84970S84989A2115521243212442124522909206752067422620207332112175049L8475521672216718248484947849468515284997C84997A84997D228052277121931223558248485099F2117582599207252072722384207282071920718207242067720675206742067684997B212422210384993A21244212432124521240212392123820676212122277422775227732277222845228442257182001S207272271921774218818248221754211642280521242206762108021212212388483621121218442264584970S15056N215582103521041475802075420718207242235615056N35004C79321227782284521658843782067622352216712167321669216702167284997D84997C2072521240210682123121210210802198921242212442124521243211232175485099F2071321930219282241121934217732072521668227742167021669216712167321754218992124321244220888259984997B84997D84997C84997A84509A84510A222622184472799F206752067720674206762156185099C85099F2071922356217312284437448221972206185232A2241184520B22088215592155884997C2165822494212442124521033215592156121558206752175485099B84997B84997D2217572760B2112222494215632156484997C84997A216732167221671216702166922774217312193415056N224942247021329213282132722262227752277421669216702290822908219892250279321215232208784509C84946213132067915056N222622217084970S22171474214742222470213272263722325227882082922313217332252185032B2138085019A2186721867214392289185163B1601621755848652155785167B848322211247559B4758021035848368437821658219472194921899215632156417136A2112121122206653733321166211698258182567825832227822276211632115984912B214702146784849D84971S84997C84997A2208922090220882075084596B84596F22176216732116421987219892068522646207282210321564217332112184378222622061884949211758515285014A15056N85014B851502155672760B84559B227522224185163B221712215122152221752231822170222472189984971S2167321672216712167020750215572277222241848368518722361223632236421122222622216272760B8520085150825992116915056BL15056N2217622318222428497822778227752166922774824862192820713207122193137444B37444A84849D2226222620851872145647590A2231885205B35920848362138917136A84997A22284215638248322121359242117584949227732155884849D2194784912A15056BL15056N219302211222291222762082985185B2216235637A215633592185163B85099C223522193121673226452072522087359242145615056N217552167222771228052228485205B21380226372226284997A84997D20829219492241147580215638483285188A223552217184509A22772216712167285185B2072684849D84832222812277020733211662132784510A2065585188A21470211102144522090208292235215056N222412175584865213292116985071D82567214702208621121219472188320655213802226220665210352192921928224112166821754400012071922719228442072479321216692072585099B2072784946212402067521244210332193182001S85099B82482213138497821314226632241122385222812111022613220882290822805227732175515056N825832082947590A2066585071D85071A84849D224182242084563A2147072799F8248421240215232067721243212442067521239211652116637444C37444A84750B84849D2198721121211222153782613A851872228184997A226632224182583824868248372760B79321212388497822364228452224175049L4742147590A2277122805206552123922325222628248384997A223182278815056N85014A21470215592217120725219312072622355216682208717129F21080215234818721558216722167021673216692271922774227722217122170213862229121169217312262085232A21755219342228185150211692143921380220902208922088225258518782483213142131385099B2193622101207282131375049L2121848173C4818548111481162124222197714598497822087824838248622104848328494621989225258515221755213802173320829206658437821035215578258184912A2209022321224112103385188A22291359212275221389215632156422771228052208782494L218844758021563215642252120829213802246722778849782271917129F219313744621035214702116622089225232065584997A85200213892229122525225582275522758227562275322754227578494982613C2138085188A215642275822757227562275522754227532198722243826002208885205B21171224112319923201232052320422661232052320823206851972228115056P2145921212216692167122355712792195582001S85099B2277522355223562072320724223832072622382223842072520727207282241121929226632193020711223852103321928223862193120712211758515222670231822267122672226752267422673850532245715056N15056P2144784563A2227882613A206558494922637226202262021731223322233122333223342209022089220882208722908213272132922281847892101221564220872075021928219292241120750221752156484997A221622215184949208292213922457219342319923201851522117584832226202186485014B15056BL15056N2208821931223844000320676206742072775049L84755849787145922386207122241185099F85099B227782167321672216702166921668217922266321211219882279620750218992140884997D21380227662217584997A21731231402314121115217332156321564211662116482600232564758015056N15056BL21557226372213921033223852192822457849782316885099B2193020711224272238685099F21931207192071221929226612238322382207182308484997C2319223191231902316523167231662237946138B2320621559221522156346138B232062241122178219312213921929223862266385099C85099F22386207122237921175712702186747590B22766226612071923208475802238315056N207282082920726207242072322356212452124284997A84997B232052320885099F22386207122192985099C84510A2320422383232012209084509A85099C23208231992238621929207272071220718228962071923205207262072385099F2325622382207282238422139216702308415056BL2275284692227572275822756232052235620724207232072620725219292103385099F85099B8497875049L17129F8248422774227722277121314227782316815056BL15056N84849D82613D826002227884997A84997C71270712702115922663211692275221467211152143984997B84997D22891227582155784970S20829213802173122382220832111548194226612072722663207192303423035230332242722103714772238217129F82001S20685232042071923206207282319923201224112238685099B21928219312189984596B84596F2111521166215562117121163213802173115056N15056BL22083826002156484347212312208321559224112193185099C2308923084217311600882001S21137227552275621787214472204121175211792116923182211942120815056N2067921557223162319247590A211242319623197231982242622278223158505384596F2328523286232872328818097C228912235447559B47580231992266385099B17091J2257122572210332238647590A2156321557227522111082613D17091J15056N206792173123201223852316623165231632242623182226712303520829220452167322548217902267022409224072240622408224072217921980219832198522615224682198221984219672261647310M2071221137160084811185159A85159B219302071185014B82613D22671208292121120898218672275622753227582275722754227552262022139231822215121447212328248622905229042290323197162252319223190229082178747351B2238675049L223602303322426230352308921716217152277371477227732277422041217182142821672216692290816225224672066584347229052116922671231822319823196231971600885014B15056N15056BL21671216682152348187231682303484569A84569D15056BL15056N20711219302071282600207262072421669216682167121670216722310417129F2113722467824862124585099F2192922775232062238322384207271600821731231822319647310M208292113721718217152318222316227552240923166231672319823197223152231615056BL71459207331600815056N15056BL22316231822277547310M22178231672267084970L2221922139214242142623198231962319723198217542240622409219862179121790226702178721930223862319985099C226702198222409217872247648173C15056BL22755211372131347310M82001S2316822197220412231648173C15056BL15056N85099B2267523201225482318272802A2213547351B1600823198712702121021424214272142822406217182171621467231672308922315223642277817129F213137147775049L8497847351B23168231652284482001S21137160082275215056BL15056N22620217552175448173C21934226372308922409214302240722408224104748047471217312267022665221512275722756227582275322754227552319823197231962267221447208292217421428228918256782600211752267521425214272290422905229032179021791225482254916225224062171822560222972198721439218672065584997D84997C84997A84997B221392293922990214702070479302M21989217152171622134231542210148173C221782235221470216692277385099C2316723166223862071322674226752232622328223272232922410227552233322411207122193021929219342267522670226732267415056N15056BL2303123029230322302822758217872082922646226452318446118214282217922326227212236223403219282192922663207112241121930207122217322682226832268022681226842268522670226792268622677226712267222673226782267684406B2314723146231482082922427227582232684949221322213379066K2318247563A84912A221398483220655213292189921327224292194723016215312264422637221792116621867209862250085014B85014A213802275221684231842153023142228982289921523230892242715056BL21791222162179022904230361622522644226462192920711211662227822674226912269222414223652236685014A206792316921110850531622523190231922319122754226202278144089C44089A8434721327213292231822085226712290421380226282257185099B79066K2238621928475802268622685226812233122406843472266321561215592113720713233152331623317214272241023026231632189222310215302264422646232752264522757219342268321427212573592422227231972275522686226852267622671218822188022326214702303184970L2120721166211652232715056BL8434784510A208292213984509A2316822467231662316585159B217747145948184231692208385099C22411207122268622676226702267722679226812302923032227582327522409218122318221086223322233315056N15056BL16008226632193421121226802267623032221712267715056P2331622366226202231085014B2132921791213272117422326227582198721881223312227621530227562188221812218112186421866230312275722162475802233222333212574818479302M4818522678226832314715056BL2173122326232752303122677226862268023148222972290521232217902236684600215302303221811227552213917091J211372121022686226782268322682226762267722685212588460084510A23275226208434715056BL208292267421731222278494784347215582314822663215302275821012229042213921094207132246822905226792275822755230322217521530224262104184510A23147226718434715056BL21755215312263722386219342319622758222272155822904843752173122161226822267722678843472240723169224672125884947211372275522758231682327548173C849472242616008225562319722572225712213921879218832188121880226202193422426229622296322227221392314716008843478248684510A22753227572138015056BL15056N23031231462241115056N15056BL21773227572181122904229052290322227226852268222683226782267622671226772268022670226812268422686226792267222754227562275322673226752267423163160082318222310211212188384375231462186722175851502116421169851522117521530224682217921211211642198821557226204742120679220652296322962211372316823166231672238620712227782213922844219342193021929219282131375049L84945847924811182483824822266385099C224112217182001S217312143915056P21987843472206582486206852222723271223332115947559B2082923397481872181184347218922314821812220782101222227223652242623168207112179122152215302275422753227562275723317233152250072800E160082184422227231962318422310217872267421880218822192822663221792082921892843752242920712220832316922467725982222735001G211101601621949218998483684347211694811684970S2067979302M8505321012233972236547563A21470214282082923026232752238685099C224114818821169207182072485099B223278469223031213808520285204852032319784347233162331522265207132279415056BL2204121169843472278123315233162275584971S442354423444235227582275523197226912113721258224142152448116231692331523316233172179022678222622189222227217182171623184231962193185099B84347224108494523147231482240647310M79302M2290546118849782275221258233262131348187233172319721012222272279423182217558505323110211692125823168231672131421137442348434725.5434644 days0.316354474.0419.71428626.142857
99160982005.6387.07.0613.01000221912218322241122379223812279822726229262283922838227832292622782224112091422381206812269022730227282272722381223792241122926230942241184673B84673A2188823080223812299222411227262273022727227252091423094229922241115039209148407722728227292331523316227302272522726227272272822729227272273022725224112272622726219122188884754232152321429.93477647 days0.0244760.087.5714299.571429

Last rows

df_indexcustomer_idgross_revenuerecency_daysqtde_invoicesqtde_itemsqtde_productsavg_ticketavg_recency_daysfrequencyqtde_returnsavg_basket_sizeavg_unique_basket_size
29595627177271060.2515.01.0645.08505321928219292358123203229962300484978849462205122986232312354616156S215232269248187235972329822169221702309323408824822299047591D2296522989224252242922426850592324323337233352319821977233072329522624226272272023245229792298022978229812298222993234952272222723229072310422557225552255622551225542337023366214302323623240217902262216.0643946 days0.3333336.0645.00000066.0
2960563717232421.522.02.0203.084347214842335622816228182369522030207772343922866207662076422867228652349423493233442214222966220812299120761215842148484347235762214423319207612324022428228652272622867227272334411.70888912 days0.1666670.0101.50000018.0
2961563817468137.0010.02.0116.0232042246021231225962107027.4000004 days0.5000000.058.0000002.5
2962564913596697.045.02.0406.02262523345233462297823580231162285121136848422296184997A22367228992327522949210802325421715224508499223256224292236023293218772197584991231732209123275232892329021972233132333822966215922295522951223262187784988210344818721975233722295122417232962357523241231772356023345226302350823313229482241722951226302262923084233062320323390234942349323343232992275422909229102290323371225512350822489218782262322549218892253022543233202328523288232862328723084225342254422556235102338922948235982256322562220932273023401221112161523307220932340923371232412319323194219132308022423218882162121878225542266222382224992339022516225172251422515217152171823372849782313022445224502244623197235292161523198224892337223371233778499184978224852209121136229562327122460221782324523239228132319022746227482317723194232412324221790233672334623368233454.1990367 days0.2857140.0203.00000083.0
29635655148931237.859.02.0799.085183A2278220749222772193122380232022245722089216422331079302M2308222780230792231021314224232289422907229082227884912B2116717084N17091J2207522580235812149722438224392218170007217902170521703229602137722467229692110884031B84032B84032A84031A2236147421850662311085183B233532349285049A2290922818224568248485152825822117521174211812190821166219072315523200231992320385099F85099B2320216.9568492 days1.0000000.0399.50000036.5
2964565912479473.2011.01.0382.021212212102108021086219892198721558212112121321882224378499222993226282121623243212172272021088219882109422215227342207785049E85049C2097820979209732337015.7733334 days0.37500034.0382.00000030.0
2965568014126706.137.03.0508.022274221502227322779226212245785123A209612260522433214792344420963225602096147.0753333 days1.33333350.0169.3333335.0
29665686135211092.391.03.0733.02353523301233002332022138228352211385177226512187823084851782262185039A21313219142145422620235702299323251218182181021819710502149435471D233272332621135230748497823367216842214422150218892179023189226592249484347216162162021615850592181821819221162117221905230602328121446234982342223420220912272784625A2301323014224812286322972229742332882551224022132985032A85032B85032C232932283122196210662299323293232942329521314224282218222961233682336523366235522349722196221952334023382230842259222842228402242922208222082220922211215342152821537359673596423163231622236747591D215922235222945232492325023251214942297722977210122348922071220702332022509223652277022605226072330123300219122254923526216192171384031B2067915056N229522211323356228352211122695221962295223295224242159284032B2339423396233952339321714233282353523536230892140121400233388498822190234942191422546851782318222673226712178721914210642255785231B232418505322118221192301923080848322308421718214942342222494840122329522642843752219621790219162212322942212792281122457224092240622398224002240021716224412296085061W2306023281234252241984707A22076220752247623169224742316935471D23328849472296423101231002341835970231682329522956234892263922642226382264323214218182181921810229562349523552234982349723296232932329523294212632250915056P20679206862217023084209922198421790235042209123376235062351022280222792295285176227272238923367225572255190214E2253022546225442254422533225342214422744227432349390214P90214I22651218782173921064207332198421705233002330122500216192308022940209722215085015150392262122500211152189121890220962275420996218942314421260213132138384993A848792113621718225222318985169A85169C85026B2249521494230742330922132220992339820986220972162085231B21976849918497822139214392267121172231882199321329235512110922119224732247422209224222339947469223982240223356221112283522113221102221022211222082144679063C22620231222163821640209752299322075220742207622481225632256222564222762207222109221082212484596B232522247523340223142293870006233682336620975225612295522472848192159121592846923597022642223432219621563221952153021977231232086821715226382264323212211622328123382231002181921810232122321521810218082180322955229562332022094229422.5112414 days0.3333330.0244.333333145.0
2967569615060301.848.04.0262.022485224562346123090214942115484876B84877B215922199135471D85049A85049E235622298223100232752308422616229522125822597227342369485049A2202822209229522226635810B2161621619216158511185183A22500233952339422654231982235822507222782103485177233782261623376233782357117012D17012B2115485049E22734225858517685183A85049A225782257723359219912220922952222082337822597225782257785111226972346123090223782346185049E23354215922108022654231002327523352233512235823570221151625421616216152161935471D85032B223492234884877B84876B84876B2198085032C227542275520755207772234823394233952142821034224562066822456220302240223291232922349921916219912.5153331 days4.0000000.065.50000030.0
2968571512558269.967.01.0196.0227122334485099B2320979191C23392848282315821507215082202724.5418186 days0.333333196.0196.00000011.0